Trigger Type
Choose Table or View on which the DML trigger is executed.
Enable
Check this option to enable the trigger.
Table Name or View Name
Choose a table or a view.
Fire
After
Specify that the DML trigger is fired only when all operations specified in the triggering SQL statement have executed successfully.Instead of
Specify that the DML trigger is executed instead of the triggering SQL statement, therefore, overriding the actions of the triggering statements.
On event
Insert
The trigger is activated whenever a new row is inserted into the table.
Update
The trigger is activated whenever a row is modified.
Delete
The trigger is activated whenever a row is deleted from the table.
Definition Type
Choose the definition type.
Note: Support from SQL Server 2005 or later.